mysql after 报错

您所在的位置:网站首页 MySQL启动报错 ibtmp1 mysql after 报错

mysql after 报错

#mysql after 报错| 来源: 网络整理| 查看: 265

出错的内容:

908be4a27ab54b1aa8f6c40b16b342fb.png

备注:这里大概意思是意外关闭数据库造成的错误,让我检查日志文件和端口

日志文件报错:

InnoDB: using atomic writes.

2020-08-13 20:31:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2020-08-13 20:31:52 0 [Note] InnoDB: Uses event mutexes

2020-08-13 20:31:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2020-08-13 20:31:52 0 [Note] InnoDB: Number of pools: 1

2020-08-13 20:31:52 0 [Note] InnoDB: Using SSE2 crc32 instructions

2020-08-13 20:31:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2020-08-13 20:31:52 0 [Note] InnoDB: Completed initialization of buffer pool

2020-08-13 20:31:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2020-08-13 20:31:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2020-08-13 20:31:52 0 [Note] InnoDB: Setting file 'E:\xammp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2020-08-13 20:31:52 0 [Note] InnoDB: File 'E:\xammp\mysql\data\ibtmp1' size is now 12 MB.

2020-08-13 20:31:52 0 [Note] InnoDB: Waiting for purge to start

2020-08-13 20:31:52 0 [Note] InnoDB: 10.4.11 started; log sequence number 447771; transaction id 807

2020-08-13 20:31:52 0 [Note] InnoDB: Loading buffer pool(s) from E:\xammp\mysql\data\ib_buffer_pool

2020-08-13 20:31:52 0 [Note] Plugin 'FEEDBACK' is disabled.

2020-08-13 20:31:52 0 [Note] Server socket created on IP: '::'.

解决办法:

方法一:

改端口。打开Mysql的my.ini文件,将端口3306改成3307或者3316都可

改完后保存重新启动

方法二:

方法三:

在mysql/bin/my.ini 文件下的[mysqld]加一个:innodb_force_recovery = 4

保存重启

方法四:

8e281da52cffc8dbc8d9ef7e18247371.png

将图中的带@的文件删除,请注意看时间,和你出错的时间相仿的。

重启

以上就是关于这个问题的解决办法,如果还是不能解决,请百度。



【本文地址】


今日新闻


推荐新闻


CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3